package cn.gson.boot.model.dao;

import cn.gson.boot.model.pojos.Kehu;
import cn.gson.boot.model.pojos.Quotation;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import java.util.List;

public interface HTBaoJiaDanDao extends CrudRepository<Quotation,Integer> {
    //根据客户名称来查询客户所对应的报价单
    @Query(nativeQuery = true,value = "select * from quotation_ where k_id = ?1 and Quotation_sc = 0")
    public List<Quotation> selectBojiaDanByKeHu(Integer khid);


   /* @Query("select k.kName from Kehu k")
    public List<Kehu> selectKehu();*/
}
